<!DOCTYPE html>
<html lang="zh-cn">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" href="../../favicon.ico">

    <title>音乐分享管理系统</title>

    <!-- Bootstrap core CSS -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="assets/css/offcanvas.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
    <!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
    <!--[if lt IE 9]>
    <script src="assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
    <script src="assets/js/ie-emulation-modes-warning.js"></script>

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
    <script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>

<body>
<?php 
require_once('tpl/head.php');
 ?>
<nav class="navbar navbar-fixed-top navbar-inverse">
  <div class="container-fluid">
    <!-- Brand and toggle get grouped for better mobile display -->
    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
     
    </div>

    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
    <ul class="nav navbar-nav">


        <ul class="nav navbar-nav">
        <li><a href="index.php">首页</a></li>
        <?php

          foreach ($data['musics6'] as $row)
        {
        ?>
        <li><a href="index.php?c=index&m=lists&tid=<?php
        echo $row["tid"];
        ?>
        "><?php
        echo $row["typename"];
        ?>
        </a></li>
        <?php
          }
        ?>
        </ul>
    </ul>

        <form action="search.php"class="navbar-form navbar-left" role="search" >
        <div class="form-group">
 
        <input type="text" class="form-control" name="musicname" placeholder="Search">
        </div>

        <button type="submit" class="btn btn-default">搜索</button>
        </form>

        <ul class="nav navbar-nav navbar-right">
        <li class="active"><a href="">欢迎<?php
        session_start();
        if(isset($_SESSION["user"]))
        echo " ".$_SESSION["user"]." ";
        else{

        echo "您";
        }
        ?>访问本网站</a>
        </li>

        <?php
        //登录成功才显示
        if(isset($_SESSION["user"]))
        {
        ?>
        <li><a href="logout.php">注销</a></li>
        <li class="dropdown">
        <a
        href="#"
        class="dropdown-toggle"
        data-toggle="dropdown"
        role="button"
        aria-haspopup="true" aria-expanded="false">个人中心  <span class="caret"></span></a>
        <ul class="dropdown-menu">
        <li><a href="#" data-toggle="modal" data-target="#changePassword">修改个人密
        码</a></li>
        <li><a href="#" data-toggle="modal"  data-target="#changeInfor">修改个 人信息
        </a></li>
        <li><a href="myCommentList.php" >我的评价</a></li>
        </ul>
        </li>
        
        <?php
        }else{
        ?>
   
        <li><a href="#" data-toggle="modal" data-target="#login">登录</a></li>
        <li><a href="#" data-toggle="modal" data-target="#reg">注册</a></li>
        <?php
        }
        ?>
        </ul>

          
      
    
     
    </div><!-- /.navbar-collapse -->
  </div><!-- /.container-fluid -->
</nav>

<!-- /.navbar -->
<?php
require_once('tpl/head.php');
//include_once('./system/dbConn.php');
//连接数据库
// connect();
//类型 id是通过  GET方法提交的
//根据类型 id从数据库中查询属于该类型的所有视频信息
$tid = $_GET['tid'];
$sql0="select * from musictype where tid=$tid";
$result0 = mysql_query($sql0) or die('查询失败！'.mysql_error());
$row0 = mysql_fetch_assoc($result0);
$sql = "select * from musics where tid={$tid}";
$result = mysql_query($sql) or die('查询失败！'.mysql_error());
//获取指定的页码
//判断是否指定第几页，如果没有指定，则显示第 1页。
if(!isset($_GET["page"]))
$page=1;
else{
$page=$_GET["page"];
}
//获取总行数，用于计算分几页显示
$result = mysql_query($sql);
$totalrows = mysql_num_rows($result);
//定义每页显示的行数
$rowsperpage =8;
//计算从表中第几行开始输出
$start = ($page-1) * $rowsperpage;
//查询用户，从第$start行开始，共查询$rowsperpage行。
$sql .= " limit {$start}, {$rowsperpage}";
//echo $sql.'<br/>';
//执行 sql语句
$result = mysql_query($sql) or die('查询失败！'.mysql_error());
//查询该类型下的下载排行信息
$sql1 = "select * from musics where tid={$tid} order by downtimes desc  limit 4";
$result1 = mysql_query($sql1) or die('查询失败！'.mysql_error());
 
?>

<div class="container">

    <div class="row row-offcanvas row-offcanvas-right">

        <div class="col-xs-12 col-sm-9">


            <div class="row">


                <div class="col-xs-12 col-lg-12 mlist">
                <h2><?php echo $row0["typename"];?>专栏</h2>
                <ul class="list-inline row text-center">
                <?php
                     foreach($data['musics7'] as $row)
                        {
                   ?>
                <li class="col-xs-6 col-lg-3">
                <img src="upload/<?php echo $row["pic"];?>" class="responsive img-thumbnail"/>
                <p><a href="index.php?c=index&m=content&vid=<?php echo $row["vid"];?>"><?php echo $row["musicname"];?></a></p>
                </li>
                <?php
                    }
                  ?>
                </ul>

<nav class="text-center">


                        <ul class="pagination">
                            <li>
                                <a href="#" aria-label="Previous">
                                    <span aria-hidden="true">&laquo;</span>
                                </a>
                            </li>
                            <li><a href="#">1</a></li>
                            <li><a href="#">2</a></li>
                            <li><a href="#">3</a></li>
                            <li><a href="#">4</a></li>
                            <li><a href="#">5</a></li>
                            <li>
                                <a href="#" aria-label="Next">
                                    <span aria-hidden="true">&raquo;</span>
                                </a>
                            </li>
                        </ul>
                    </nav>


                </div>
                <!--/.col-xs-6.col-lg-4-->

            </div>
            <!--/row-->
        </div>
        <!--/.col-xs-12.col-sm-9-->

        <div class="col-xs-6 col-sm-3 sidebar-offcanvas" id="sidebar">
            <div class="list-group text-center" >
                <h2 style="color:white;">网络热歌榜</h2>

                  <ul class="list-inline row text-center">
                  <?php
                       foreach($data['Topdown2'] as $row)
                    {

                          ?>
                        <li class="col-xs-12 col-lg-6">
                        <img src="upload/<?php echo $row["pic"];?>" class="responsive img-thumbnail"/>
                        <p><a href="index.php?c=index&m=content&vid=<?php echo $row["vid"];?>"><?php echo $row["musicname"];?></a>
                        </p>
                     </p>
                   </li>
                   <?php
                        }
                   ?>
                 </ul>
              </div>

        </div>
        <!--/.sidebar-offcanvas-->
    </div>
    <!--/row-->

    

</div>
<!--/.container-->
<hr>

    <footer>
        <p>&copy; Company 2014</p>
    </footer>

<?php 
require_once('tpl/foot.php');
?>
</body>
</html>
